BEGIN;

-------------------------------------------------------------------------------------------------------
-- PRA2 - EX2
-------------------------------------------------------------------------------------------------------


CREATE PROCEDURE Hipertension_Restaurant_Ranking_SP (saltIngredientCode LIKE ingredients.codi_ingredient)
                 RETURNING CHAR(50)  as Restaurant, INTEGER as total_receipts, INTEGER as total_receipts_salt,  INTEGER as total_receipts_nosalt, DECIMAL(5,2) as average_salt_in_receipts


END PROCEDURE;


COMMIT;